Song | Album | Recording |
---|---|---|
Ruby | Man and His Soul, A | 5800 |
" | Great Movie Themes | 9312 |
" | In a Romantic Mood | 10321 |
SELECT PCS.Name AS "Song", ALB.Name AS "Album", REC.ID AS "Recording" FROM Recordings REC JOIN Pieces PCS ON PCS.ID = REC.Piece_FK JOIN Albums ALB ON ALB.ID = REC.ALBUM_FK WHERE PCS. Name = "Ruby"